Tabela TimePatternTimeSlot

Definicja tabeli TimePatternTimeSlot

Name

TimePatternTimeSlot

Code

TimePatternTimeSlot

Comment

PL: Przedzial czasowy dla wzorca i danego dnia tygodnia. Np 8-16 co srode.
Uwaga: zazwyczaj StartDT i StopDT nie sa uzupelniane. Jest to wtedy wpis wzorcowy. Jesli jednak sa uzupelnione, jest to wpis instancyjny, jednorazowy. Czy oznacza on nieobecnosc czy obeznosc, determinuje timeslottype i timeslotmetatype.
WorksOnFreeDay - obowiazuje w dzien wolny
EN: Time slots in scheduler definitions


Lista kolumn tabeli TimePatternTimeSlot

Name

Code

TimePatternTimeSlotID

TimePatternTimeSlotID

TimePatternID

TimePatternID

FrequencyID

FrequencyID

TimeslotTypeID

TimeslotTypeID

Sex

Sex

Tim_TimePatternTimeSlotID

Tim_TimePatternTimeSlotID

StartDT

StartDT

StopDT

StopDT

StartT

StartT

StopT

StopT

Description

Description

OnlyVIP

OnlyVIP

AgeBottom

AgeBottom

AgeTop

AgeTop

WorksOnFreeDay

WorksOnFreeDay

AdditionalVisisCount

AdditionalVisisCount

PayerAttribute1

PayerAttribute1

PayerAttribute2

PayerAttribute2

PayerAttribute3

PayerAttribute3

PayerAbonament

PayerAbonament

ExtOrgUnitAllowed

ExtOrgUnitAllowed

IntOrgUnitAllowed

IntOrgUnitAllowed

NoOrgUnitAllowed

NoOrgUnitAllowed

PerformingDoctor

PerformingDoctor

Cito

Cito

UserDefinedTimeSlotTypeID

UserDefinedTimeSlotTypeID

RepeatDays

RepeatDays


Kolumna TimePatternTimeSlotID tabeli TimePatternTimeSlot

Definicja kolumny TimePatternTimeSlotID tabeli TimePatternTimeSlot

Name

TimePatternTimeSlotID

Code

TimePatternTimeSlotID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TimePatternID tabeli TimePatternTimeSlot

Definicja kolumny TimePatternID tabeli TimePatternTimeSlot

Name

TimePatternID

Code

TimePatternID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna FrequencyID tabeli TimePatternTimeSlot

Definicja kolumny FrequencyID tabeli TimePatternTimeSlot

Name

FrequencyID

Code

FrequencyID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TimeslotTypeID tabeli TimePatternTimeSlot

Definicja kolumny TimeslotTypeID tabeli TimePatternTimeSlot

Name

TimeslotTypeID

Code

TimeslotTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Sex tabeli TimePatternTimeSlot

Definicja kolumny Sex tabeli TimePatternTimeSlot

Name

Sex

Code

Sex

Data Type

VARCHAR2(1)

Mandatory

No

Comment

PL: Plec
EN: Sex of the person
DE: das Geschlecht


Kolumna Tim_TimePatternTimeSlotID tabeli TimePatternTimeSlot

Definicja kolumny Tim_TimePatternTimeSlotID tabeli TimePatternTimeSlot

Name

Tim_TimePatternTimeSlotID

Code

Tim_TimePatternTimeSlotID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli TimePatternTimeSlot

Definicja kolumny StartDT tabeli TimePatternTimeSlot

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli TimePatternTimeSlot

Definicja kolumny StopDT tabeli TimePatternTimeSlot

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna StartT tabeli TimePatternTimeSlot

Definicja kolumny StartT tabeli TimePatternTimeSlot

Name

StartT

Code

StartT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopT tabeli TimePatternTimeSlot

Definicja kolumny StopT tabeli TimePatternTimeSlot

Name

StopT

Code

StopT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Description tabeli TimePatternTimeSlot

Definicja kolumny Description tabeli TimePatternTimeSlot

Name

Description

Code

Description

Data Type

VARCHAR2(128)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna OnlyVIP tabeli TimePatternTimeSlot

Definicja kolumny OnlyVIP tabeli TimePatternTimeSlot

Name

OnlyVIP

Code

OnlyVIP

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna AgeBottom tabeli TimePatternTimeSlot

Definicja kolumny AgeBottom tabeli TimePatternTimeSlot

Name

AgeBottom

Code

AgeBottom

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AgeTop tabeli TimePatternTimeSlot

Definicja kolumny AgeTop tabeli TimePatternTimeSlot

Name

AgeTop

Code

AgeTop

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna WorksOnFreeDay tabeli TimePatternTimeSlot

Definicja kolumny WorksOnFreeDay tabeli TimePatternTimeSlot

Name

WorksOnFreeDay

Code

WorksOnFreeDay

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AdditionalVisisCount tabeli TimePatternTimeSlot

Definicja kolumny AdditionalVisisCount tabeli TimePatternTimeSlot

Name

AdditionalVisisCount

Code

AdditionalVisisCount

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PayerAttribute1 tabeli TimePatternTimeSlot

Definicja kolumny PayerAttribute1 tabeli TimePatternTimeSlot

Name

PayerAttribute1

Code

PayerAttribute1

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PayerAttribute2 tabeli TimePatternTimeSlot

Definicja kolumny PayerAttribute2 tabeli TimePatternTimeSlot

Name

PayerAttribute2

Code

PayerAttribute2

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PayerAttribute3 tabeli TimePatternTimeSlot

Definicja kolumny PayerAttribute3 tabeli TimePatternTimeSlot

Name

PayerAttribute3

Code

PayerAttribute3

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PayerAbonament tabeli TimePatternTimeSlot

Definicja kolumny PayerAbonament tabeli TimePatternTimeSlot

Name

PayerAbonament

Code

PayerAbonament

Data Type

NUMBER(5)

Mandatory

No

Comment

Atrybut opisuje ceche grafika, która informuje nas czy na dany grafik mozna zarezerwowac wizyte która zostanie wykonana w ramach umowy (abonamentu)


Kolumna ExtOrgUnitAllowed tabeli TimePatternTimeSlot

Definicja kolumny ExtOrgUnitAllowed tabeli TimePatternTimeSlot

Name

ExtOrgUnitAllowed

Code

ExtOrgUnitAllowed

Data Type

NUMBER(5)

Mandatory

No

Comment

Skojarzenie przedzialu czasowego z zewnetrznymi
jednostkami kierujacymi.


Kolumna IntOrgUnitAllowed tabeli TimePatternTimeSlot

Definicja kolumny IntOrgUnitAllowed tabeli TimePatternTimeSlot

Name

IntOrgUnitAllowed

Code

IntOrgUnitAllowed

Data Type

NUMBER(5)

Mandatory

No

Comment

Skojarzenie przedzialu czasowego z wewnetrznymi
jednostkami kierujacymi.


Kolumna NoOrgUnitAllowed tabeli TimePatternTimeSlot

Definicja kolumny NoOrgUnitAllowed tabeli TimePatternTimeSlot

Name

NoOrgUnitAllowed

Code

NoOrgUnitAllowed

Data Type

NUMBER(5)

Mandatory

No

Comment

Przedzial czasowy dostepny dla skierowan bez
jednostki kierujacej (bez skierowania).


Kolumna PerformingDoctor tabeli TimePatternTimeSlot

Definicja kolumny PerformingDoctor tabeli TimePatternTimeSlot

Name

PerformingDoctor

Code

PerformingDoctor

Data Type

NUMBER(10)

Mandatory

No

Comment

Lekarz wykonujacy badanie


Kolumna Cito tabeli TimePatternTimeSlot

Definicja kolumny Cito tabeli TimePatternTimeSlot

Name

Cito

Code

Cito

Data Type

NUMBER(5)

Mandatory

No

Comment

Okresla czy dany przedzial sluzy do zlecen cito


Kolumna UserDefinedTimeSlotTypeID tabeli TimePatternTimeSlot

Definicja kolumny UserDefinedTimeSlotTypeID tabeli TimePatternTimeSlot

Name

UserDefinedTimeSlotTypeID

Code

UserDefinedTimeSlotTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Wybrany przez uzytkownika typ przedzialu czasowego


Kolumna RepeatDays tabeli TimePatternTimeSlot

Definicja kolumny RepeatDays tabeli TimePatternTimeSlot

Name

RepeatDays

Code

RepeatDays

Data Type

NUMBER(10)

Mandatory

No

Comment

pole przechowuje liczbe dni, co ile obowiazuje dany przedzial


Lista kluczy tabeli TimePatternTimeSlot

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TimePatternTimeSlot

Definicja klucza Identifier_1 tabeli TimePatternTimeSlot

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment